<?php

if (!defined('BASEPATH'))
    exit('Tidak Diperkenankan mengakses langsung');
/* Class  Control : city  * di Buat oleh Diar PHP Generator  *  By Diar */

class ctrcity extends CI_Controller {

    function __construct() {
        parent::__construct();
    }

    function index($xAwal = 0, $xSearch = '') {
//  $this->load->view('test.php');
        $idpegawai = $this->session->userdata('idpegawai');
        if (empty($idpegawai)) {
            redirect(site_url(), '');
        }
        if ($xAwal <= -1) {
            $xAwal = 0;
        } $this->session->set_userdata('awal', $xAwal);
        $this->createformcity('0', $xAwal);
    }

    function createformcity($xidx, $xAwal = 0, $xSearch = '') {
        $this->load->helper('form');
        $this->load->helper('html');
        $this->load->model('modelgetmenu');
        $xAddJs = '<script language="javascript" type="text/javascript" src="' . base_url() . 'resource/ajax/baseurl.js"></script>' .
                '<script language="javascript" type="text/javascript" src="' . base_url() . 'resource/ajax/ajaxcity.js"></script>';
        echo $this->modelgetmenu->SetViewAdmin($this->setDetailFormcity($xidx), '', '', $xAddJs, '');
    }

    function setDetailFormcity($xidx) {
        $this->load->helper('form');
        $xBufResult = '';
        $xBufResult = '<div id="stylized" class="myform"><h3>city</h3><div class="garis"></div>' . form_open_multipart('ctrcity/inserttable', array('id' => 'form', 'name' => 'form'));
        $this->load->helper('common');
        $xBufResult .= '<input type="hidden" name="edidx" id="edidx" value="0" />';
        $this->load->model('modelstate');
        $xBufResult .= setForm('edidstate', 'State', form_dropdown('edidstate', $this->modelstate->getArrayListstate(), '', ' id="edidstate" onChange="dosearchcity(\'0\');" class="require" style="width:200px;" ')) . '<div class="spacer"></div>';
//        $xBufResult .= setForm('edidstate', 'idstate', form_input(getArrayObj('edidstate', '', '100'))) . '<div class="spacer"></div>';
        $xBufResult .= setForm('edcity', 'City', form_input(getArrayObj('edcity', '', '200'))) . '<div class="spacer"></div>';
        $xBufResult .= setForm('edcode', 'Code', form_input(getArrayObj('edcode', '', '100'))) . '<div class="spacer"></div>';
//        $xBufResult .= setForm('eddatein', 'datein', form_input(getArrayObj('eddatein', '', '100'))) . '<div class="spacer"></div>';
//        $xBufResult .= setForm('edidpegawai', 'idpegawai', form_input(getArrayObj('edidpegawai', '', '100'))) . '<div class="spacer"></div>';
        $xBufResult .= '<div class="garis"></div>' . form_button('btSimpan', 'simpan', 'onclick="dosimpancity();"') . form_button('btNew', 'new', 'onclick="doClearcity();"') . '<div class="spacer"></div><div id="tabledatacity">' . $this->getlistcity(0,'', '') . '</div><div class="spacer"></div>';
        return $xBufResult;
    }

    function getlistcity($xAwal,$xidstate, $xSearch) {
        $xLimit = 10;
        $this->load->helper('form');
        $this->load->helper('common');
        $xbufResult = tbaddrow(tbaddcell('No', '', 'width=10%') .
//                tbaddcell('idstate', '', 'width=10%') .
                tbaddcell('city', '', 'width=50%') .
                tbaddcell('code', '', 'width=20%') .
//                tbaddcell('datein', '', 'width=10%') .
//                tbaddcell('idpegawai', '', 'width=10%') .
                tbaddcell('Edit/Hapus', 'padding:5px;', 'width:10%;text-align:center;'), '', TRUE);
        $this->load->model('modelcity');
        $xQuery = $this->modelcity->getListcitybyidstate($xAwal, $xLimit,$xidstate, $xSearch = '');
        $ino =1+$xAwal;
        foreach ($xQuery->result() as $row) {
            $xButtonEdit = '<img src="' . base_url() . 'resource/imgbtn/edit.png" alt="Edit Data" onclick = "doeditcity(\'' . $row->idx . '\');" style="border:none;width:20px"/>';
            $xButtonHapus = '<img src="' . base_url() . 'resource/imgbtn/delete_table.png" alt="Hapus Data" onclick = "dohapuscity(\'' . $row->idx . '\',\'' . substr($row->idstate, 0, 20) . '\');" style="border:none;">';
            $xbufResult .= tbaddrow(tbaddcell($row->idx) .
                    tbaddcell($row->city) .
                    tbaddcell($row->code) .
                    tbaddcell($xButtonEdit . '&nbsp/&nbsp' . $xButtonHapus));
        }
        $xInput = form_input(getArrayObj('edSearch', '', '200'));
        $xButtonSearch = '<img src="' . base_url() . 'resource/imgbtn/b_view.png" alt="Search Data" onclick = "dosearchcity(0);" style="border:none;width:30px;height:30px;" />';
        $xButtonPrev = '<img src="' . base_url() . 'resource/imgbtn/b_prevpage.png" style="border:none;width:20px;" onclick = "dosearchcity(' . ($xAwal - $xLimit) . ');"/>';
        $xButtonNext = '<img src="' . base_url() . 'resource/imgbtn/b_nextpage.png" style="border:none;width:20px;" onclick = "dosearchcity(' . ($xAwal + $xLimit) . ');" />';
        $xbufResult .= tbaddrow(tbaddcell($xInput . $xButtonSearch, '', 'width=10% colspan=2') .
                tbaddcell($xButtonPrev . '&nbsp&nbsp' . $xButtonNext, '', 'width=40% colspan =10'), '', TRUE);
        $xbufResult = tablegrid($xbufResult);
        return '<div class="tabledata"  style="width:100%;left:-12px;">' . $xbufResult . '</div>';
    }

    function editreccity() {
        $xIdEdit = $_POST['edidx'];
        $this->load->model('modelcity');
        $row = $this->modelcity->getDetailcity($xIdEdit);
        $this->load->helper('json');
        $this->json_data['idx'] = $row->idx;
        $this->json_data['idstate'] = $row->idstate;
        $this->json_data['city'] = $row->city;
        $this->json_data['code'] = $row->code;
        $this->json_data['datein'] = $row->datein;
        $this->json_data['idpegawai'] = $row->idpegawai;
        echo json_encode($this->json_data);
    }

    function deletetablecity() {
        $edidx = $_POST['edidx'];
        $this->load->model('modelcity');
        $this->modelcity->setDeletecity($edidx);
        $this->load->helper('json');
        echo json_encode(null);
    }

    function searchcity() {
        $xAwal = $_POST['xAwal'];
        $xSearch = $_POST['xSearch'];
        $xidstate = $_POST['xidstate'];
        $this->load->helper('json');
        if (($xAwal + 0) == -99) {
            $xAwal = $this->session->userdata('awal', $xAwal);
        }
        if ($xAwal + 0 <= -1) {
            $xAwal = 0;
            $this->session->set_userdata('awal', $xAwal);
        } else {
            $this->session->set_userdata('awal', $xAwal);
        }
        $this->json_data['tabledatacity'] = $this->getlistcity($xAwal,$xidstate, $xSearch);
        echo json_encode($this->json_data);
    }

    function simpancity() {
        $this->load->helper('json');
        if (!empty($_POST['edidx'])) {
            $xidx = $_POST['edidx'];
        } else {
            $xidx = '0';
        }
        $xidstate = $_POST['edidstate'];
        $xcity = $_POST['edcity'];
        $xcode = $_POST['edcode'];
        $xdatein = $_POST['eddatein'];
        $xidpegawai = $_POST['edidpegawai'];
        $this->load->model('modelcity');
        $idpegawai = $this->session->userdata('idpegawai');
        if (!empty($idpegawai)) {
            if ($xidx != '0') {
                $xStr = $this->modelcity->setUpdatecity($xidx, $xidstate, $xcity, $xcode, $xdatein, $idpegawai);
            } else {
                $xStr = $this->modelcity->setInsertcity($xidx, $xidstate, $xcity, $xcode, $xdatein, $idpegawai);
            }
        }
        echo json_encode(null);
    }

}

?>